Tabela Sample

Definicja tabeli Sample

Name

Sample

Code

Sample

Comment

 


Lista kolumn tabeli Sample

Name

Code

SampleID

SampleID

MaterialID

MaterialID

UnitID

UnitID

PersonID

PersonID

CollectionSiteID

CollectionSiteID

Pat_PersonID

Pat_PersonID

SampleNo

SampleNo

DateValue

DateValue

Amount

Amount

PerfTime

PerfTime

LabelCount

LabelCount


Kolumna SampleID tabeli Sample

Definicja kolumny SampleID tabeli Sample

Name

SampleID

Code

SampleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MaterialID tabeli Sample

Definicja kolumny MaterialID tabeli Sample

Name

MaterialID

Code

MaterialID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitID tabeli Sample

Definicja kolumny UnitID tabeli Sample

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli Sample

Definicja kolumny PersonID tabeli Sample

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CollectionSiteID tabeli Sample

Definicja kolumny CollectionSiteID tabeli Sample

Name

CollectionSiteID

Code

CollectionSiteID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Pat_PersonID tabeli Sample

Definicja kolumny Pat_PersonID tabeli Sample

Name

Pat_PersonID

Code

Pat_PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SampleNo tabeli Sample

Definicja kolumny SampleNo tabeli Sample

Name

SampleNo

Code

SampleNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna DateValue tabeli Sample

Definicja kolumny DateValue tabeli Sample

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Amount tabeli Sample

Definicja kolumny Amount tabeli Sample

Name

Amount

Code

Amount

Data Type

NUMBER(5,2)

Mandatory

No

Comment

 


Kolumna PerfTime tabeli Sample

Definicja kolumny PerfTime tabeli Sample

Name

PerfTime

Code

PerfTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LabelCount tabeli Sample

Definicja kolumny LabelCount tabeli Sample

Name

LabelCount

Code

LabelCount

Data Type

NUMBER(5)

Mandatory

No

Comment

Wydruk label-ek przy uzyciu drukarki zebra


Lista kluczy tabeli Sample

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Sample

Definicja klucza Identifier_1 tabeli Sample

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment